One moment please...
 
E-WMS   
 

E-WMS - Item/Stock View

WMS documentation

 

Introduction

This document describes the columns in the stock information screen in menu E-WMS, Reports, Item/Stock View, as available in product update 410.

 

Description

In menu E-WMS, Reports, Item/Stock view, E-WMS offers detailed insight in stock positions per item, including information on E-WMS stock reservations, which are not visible in standard Exact Globe Next stock reports.

Columns titles for reservations have a '+' or '-' indicator, which shows if the quantity is subtracted or added to available stock. Also, issue reservations quantities are shown with a '-' sign to indicate the impact for available stock more clearly.

The following default columns are shown in the warehouse (top) pane:

Column Title Description/calculation
1 Warehouse Warehouse code
2 Description Warehouse name
3 Blocked Indicates whether the warehouse status is Active or Blocked
4 Current stock
The visible stock at this time in the warehouse:
Shelf stock (5) + Received not processed (13) - Issued not processed (10)
5 Shelf stock Exact Globe Next shelf stock
6 -Allocated Total of allocations in Exact Globe Next. Since stock allocations are made on warehouse level and not on location level, this can only be shown on warehouse level.
7 Free stock Shelf stock (5) minus allocated stock (6)
8 -Reserved Total of reservations for E-WMS processes: transactions pending in E-WMS and not processed yet (from status 'advice' to status 'validated' or 'picking error')
9 +Allocated +Reserved Since stock can be allocated AND reserved (=in progress in E-WMS), this should not be counted as double stock reservation. This column shows the 'overlap' to be corrected. Example: allocated=5, of which quantity 3 also has a picking advice, then this columns shows '3'.
10 Quantity available Free stock (7) minus reservations (8) plus overlap (9)
     
  The following columns show details per process, and are part of the total in column 8 '-Reserved':
     
11 -Reserved: fulfillment Total of unprocessed issues in E-WMS sales order fulfillment
12 -Reserved: production issues Total of unprocessed issues in E-WMS production issues
13 -Reserved: stock transactions Total of unprocessed issues in E-WMS stock transactions
14 -Reserved: stock transfers Total of unprocessed issues in E-WMS transfers
15 -Reserved: stock replenishment Total of unprocessed issues in E-WMS replenishment
16 -Reserved: purchase returns Total of unprocessed returns in E-WMS receipts registration
17 +Reserved: receipts Total of unprocessed receipts in E-WMS receipts registration
18 +Reserved: production receipts Total of unprocessed receipts in E-WMS production receipts
19 +Reserved: stock transactions Total of unprocessed receipts in E-WMS stock transactions
20 +Reserved: stock transfers Total of unprocessed issues in E-WMS transfers
21 +Reserved: stock replenishment Total of unprocessed issues in E-WMS replenishment
22 +Reserved: sales: returns Total of unprocessed returns in E-WMS sales order fulfillment
23 -Issued: not processed Total of realized and unprocessed issues (part of column 11 to 16) *1
24 -To be issued Total of advised but not realized issues (part of columns 11 to 16)  *2
25 +Received: not processed Total of realized receipts (part of column 18 to 22) *1
26 +To be received Total of planned but not yet realized receipts
27 Stock change: not processes Total of all realized stock changes
     
     
*1 'realized' = scanned but not yet read back; or: read back, validated, or picking error, but not yet processed
*2  only when a picking 'advice' was generated. When picking advice is disabled there is no E-WMS reservation until the issue is scanned.
 

 
The following stock columns are shown in the detail (bottom) pane. The details are based on a full WMS license using locations, serial/batch and SKU. The columns shown are depending on selected checkmarks, license and settings. Grey columns are only visible when the checkmark 'Split quantity reserved' is enabled.

Column Title Description/calculation
1 Location Warehouse location code
2 Description Warehouse location description
3 Pick/bulk location Description of Exact Globe Next location type 'none', 'pick', or 'bulk'
4 Type Description of Exact Globe Next location type 'fixed item location', 'multiple item location', 'variable item location'.
5 Blocked for receiving Checkmark, shows the status 'Blocked for receiving'
6 Blocked for issuing Checkmark, shows the status 'Blocked for issuing'
7 Serial/batch number Serial- or batch number (these columns are only shown for serial/batch items)
8 Blocked Serial- or batch blocked status ('Checkmark'=blocked)
9 Start date Serial- or batch number start date
10 End date Serial- or batch number end date
11 Current stock The real visible stock at this time in the warehouse:  Shelf stock (1) + Received not processed (29) - Issued not processed (27)
12 Shelf stock Processed stock
13 -Reserved Total of issues reservations for E-WMS processes (all not processed issues)
14 Quantity available Available stock :  (1) - (3)
     
  Pending issues per process:  
15 -Reserved: fulfillment Reserved for E-WMS Sales Order Fulfillment (all statuses, not processed yet)
15 a -Fulfillment: reservations Reserved for E-WMS Sales Order Fulfillment process, status Advice, Picked, Validated or Picking error
15 b -Fulfillment: scanner Reserved for E-WMS Sales Order Fulfillment process, status Picking
16 -Reserved: production: issues Reserved for E-WMS Production Issues (all statuses, not processed yet)
16 a -Production: Issues: reservations Reserved for E-WMS Production Issues process, status Advice, Picked, Validated or Picking error
16 b -Production: Issues: scanner Reserved for E-WMS Production Issues process, status Picking
17 -Reserved: stock transactions Reserved for E-WMS Stock Transactions issues (all statuses, not processed yet)
17 a -Stock transactions: reservations Reserved for E-WMS Stock Transactions issues, status Picked, Validated or Picking error
17 b -Stock transactions: scanner Reserved for E-WMS Stock Transactions issues, status Picking
18 -Reserved: stock transfers Reserved for E-WMS Stock Transfers, issues (all statuses, not processed yet)
18 a -Stock transfers: reservations Reserved for E-WMS Stock Transfers issues, status Picked, Validated or Picking error
18 b -Stock transfers: scanner Reserved for E-WMS Stock Transfers issues, status Picking
19 -Reserved: stock replenishment Reserved for E-WMS Replenishment issues (all statuses, not processed yet)
19 a -Stock replenishment: reservations Reserved for E-WMS Replenishment issues, status Advice, Picked, Validated or Picking error
19 b -Stock replenishment: scanner Reserved for E-WMS Replenishment issues, status Picking
20 -Reserved: purchase: returns Reserved for E-WMS purchase receipts with negative quantity (returns; all statuses, not processed yet)
20 a -Purchase: returns: reservations Reserved for E-WMS purchase receipts with negative quantity, status Advice, Picked, Validated or Picking error
20 b -Purchase: returns: scanner Reserved for E-WMS purchase receipts with negative quantity, status Picking
     
  Pending receipts per process:  
21 +Reserved: receipts Reserved for E-WMS purchase receipts (all statuses, not processed yet)
21 a +Receipts: reservations Reserved for E-WMS purchase receipts, status Advice, Picked, Validated or Picking error
21 b +Receipts: scanner Reserved for E-WMS purchase receipts, status Picking
22 +Reserved: Production: receipts Reserved for E-WMS production receipts (all statuses, not processed yet)
22 a +Production: Receipts: reservations Reserved for E-WMS production receipts, status Picked, Validated or Picking error
22 b +Production: Receipts: scanner Reserved for E-WMS production receipts, status Picking
23 +Reserved: stock transactions Reserved for E-WMS Stock Transactions receipts  (all statuses, not processed yet)
23 a +Stock transactions: reservations Reserved for E-WMS Stock Transactions receipts, status Picked, Validated or Picking error
23 b +Stock transactions: scanner Reserved for E-WMS Stock Transactions receipts, status Picking
24 +Reserved: stock transfers Reserved for E-WMS Stock Transfers receipts (all statuses, not processed yet)
24 a +Stock transfers: reservations Reserved for E-WMS Stock Transfers receipts, status Picked, Validated or Picking error
24 b +Stock transfers: scanner Reserved for E-WMS Stock Transfers receipts, status Picking
25 +Reserved: stock replenishment Reserved for E-WMS Replenishment receipts (all statuses, not processed yet)
25 a +Stock replenishment: reservations Reserved for E-WMS Replenishment receipts, status Advice, Picked, Validated or Picking error
25 b +Stock replenishment: scanner Reserved for E-WMS Replenishment receipts, status Picking
26 +Reserved: sales: returns Reserved for E-WMS fulfillment of orders with negative quantity (returns; all statuses, not processed yet)
26 a +Sales: returns: reservations Reserved for E-WMS fulfillment of orders with negative quantity, status Advice, Picked, Validated or Picking error
26 b +Sales: returns: scanner Reserved for E-WMS fulfillment of orders with negative quantity, status Picking
     
27 Issued: not processed Total of issued picked stock (any E-WMS process, from status 'picking' to 'validated'/'picking error')
28 To be issued Total of stock to be issued but not picked yet (any E-WMS guided process with picking advice, status 'advice' and 'picking', not picked yet)
29 Received: not processed Total of picked receipts in any E-WMS process, not processed yet (status 'picking' to 'validated'/'picking error')
30 To be received Total of stock to be received but not picked yet (any E-WMS guided receipt process, status 'advice' and 'picking', not picked yet)
31 Stock change: not processed Total of all stock changes not processed yet
32 Allocated: sales order Sales order number to which the current stock quantity is allocated (WMS allocations only, available from release 410)
33 Allocated: project Project code to which the current stock quantity is allocated (WMS allocations only, available from release 410)
     

When the total stock of an item is zero in a warehouse, due to stock inconsistency (stock: +1 on location A1 and -1 on location B1), then this screen will show no stock positions for that item.

Related documents

     
 Main Category: Attachments & notes  Document Type: Support - On-line help
 Category:  Security  level: All - 0
 Sub category:  Document ID: 23.119.471
 Assortment:  Date: 22-12-2020
 Release:  Attachment:
 Disclaimer